package com.sams.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CountrySubExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CountrySubExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andProjectIsNull() {
            addCriterion("project is null");
            return (Criteria) this;
        }

        public Criteria andProjectIsNotNull() {
            addCriterion("project is not null");
            return (Criteria) this;
        }

        public Criteria andProjectEqualTo(String value) {
            addCriterion("project =", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotEqualTo(String value) {
            addCriterion("project <>", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectGreaterThan(String value) {
            addCriterion("project >", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectGreaterThanOrEqualTo(String value) {
            addCriterion("project >=", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLessThan(String value) {
            addCriterion("project <", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLessThanOrEqualTo(String value) {
            addCriterion("project <=", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLike(String value) {
            addCriterion("project like", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotLike(String value) {
            addCriterion("project not like", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectIn(List<String> values) {
            addCriterion("project in", values, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotIn(List<String> values) {
            addCriterion("project not in", values, "project");
            return (Criteria) this;
        }

        public Criteria andProjectBetween(String value1, String value2) {
            addCriterion("project between", value1, value2, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotBetween(String value1, String value2) {
            addCriterion("project not between", value1, value2, "project");
            return (Criteria) this;
        }

        public Criteria andSchidIsNull() {
            addCriterion("schid is null");
            return (Criteria) this;
        }

        public Criteria andSchidIsNotNull() {
            addCriterion("schid is not null");
            return (Criteria) this;
        }

        public Criteria andSchidEqualTo(Integer value) {
            addCriterion("schid =", value, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidNotEqualTo(Integer value) {
            addCriterion("schid <>", value, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidGreaterThan(Integer value) {
            addCriterion("schid >", value, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidGreaterThanOrEqualTo(Integer value) {
            addCriterion("schid >=", value, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidLessThan(Integer value) {
            addCriterion("schid <", value, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidLessThanOrEqualTo(Integer value) {
            addCriterion("schid <=", value, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidIn(List<Integer> values) {
            addCriterion("schid in", values, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidNotIn(List<Integer> values) {
            addCriterion("schid not in", values, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidBetween(Integer value1, Integer value2) {
            addCriterion("schid between", value1, value2, "schid");
            return (Criteria) this;
        }

        public Criteria andSchidNotBetween(Integer value1, Integer value2) {
            addCriterion("schid not between", value1, value2, "schid");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("sex like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("sex not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andGradeIsNull() {
            addCriterion("grade is null");
            return (Criteria) this;
        }

        public Criteria andGradeIsNotNull() {
            addCriterion("grade is not null");
            return (Criteria) this;
        }

        public Criteria andGradeEqualTo(String value) {
            addCriterion("grade =", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotEqualTo(String value) {
            addCriterion("grade <>", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThan(String value) {
            addCriterion("grade >", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThanOrEqualTo(String value) {
            addCriterion("grade >=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThan(String value) {
            addCriterion("grade <", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThanOrEqualTo(String value) {
            addCriterion("grade <=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLike(String value) {
            addCriterion("grade like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotLike(String value) {
            addCriterion("grade not like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeIn(List<String> values) {
            addCriterion("grade in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotIn(List<String> values) {
            addCriterion("grade not in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeBetween(String value1, String value2) {
            addCriterion("grade between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotBetween(String value1, String value2) {
            addCriterion("grade not between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andClassesIsNull() {
            addCriterion("classes is null");
            return (Criteria) this;
        }

        public Criteria andClassesIsNotNull() {
            addCriterion("classes is not null");
            return (Criteria) this;
        }

        public Criteria andClassesEqualTo(String value) {
            addCriterion("classes =", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesNotEqualTo(String value) {
            addCriterion("classes <>", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesGreaterThan(String value) {
            addCriterion("classes >", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesGreaterThanOrEqualTo(String value) {
            addCriterion("classes >=", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesLessThan(String value) {
            addCriterion("classes <", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesLessThanOrEqualTo(String value) {
            addCriterion("classes <=", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesLike(String value) {
            addCriterion("classes like", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesNotLike(String value) {
            addCriterion("classes not like", value, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesIn(List<String> values) {
            addCriterion("classes in", values, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesNotIn(List<String> values) {
            addCriterion("classes not in", values, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesBetween(String value1, String value2) {
            addCriterion("classes between", value1, value2, "classes");
            return (Criteria) this;
        }

        public Criteria andClassesNotBetween(String value1, String value2) {
            addCriterion("classes not between", value1, value2, "classes");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNull() {
            addCriterion("idcard is null");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNotNull() {
            addCriterion("idcard is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardEqualTo(String value) {
            addCriterion("idcard =", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotEqualTo(String value) {
            addCriterion("idcard <>", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThan(String value) {
            addCriterion("idcard >", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThanOrEqualTo(String value) {
            addCriterion("idcard >=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThan(String value) {
            addCriterion("idcard <", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThanOrEqualTo(String value) {
            addCriterion("idcard <=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLike(String value) {
            addCriterion("idcard like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotLike(String value) {
            addCriterion("idcard not like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardIn(List<String> values) {
            addCriterion("idcard in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotIn(List<String> values) {
            addCriterion("idcard not in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardBetween(String value1, String value2) {
            addCriterion("idcard between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotBetween(String value1, String value2) {
            addCriterion("idcard not between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andStucodeIsNull() {
            addCriterion("stucode is null");
            return (Criteria) this;
        }

        public Criteria andStucodeIsNotNull() {
            addCriterion("stucode is not null");
            return (Criteria) this;
        }

        public Criteria andStucodeEqualTo(String value) {
            addCriterion("stucode =", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeNotEqualTo(String value) {
            addCriterion("stucode <>", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeGreaterThan(String value) {
            addCriterion("stucode >", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeGreaterThanOrEqualTo(String value) {
            addCriterion("stucode >=", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeLessThan(String value) {
            addCriterion("stucode <", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeLessThanOrEqualTo(String value) {
            addCriterion("stucode <=", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeLike(String value) {
            addCriterion("stucode like", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeNotLike(String value) {
            addCriterion("stucode not like", value, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeIn(List<String> values) {
            addCriterion("stucode in", values, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeNotIn(List<String> values) {
            addCriterion("stucode not in", values, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeBetween(String value1, String value2) {
            addCriterion("stucode between", value1, value2, "stucode");
            return (Criteria) this;
        }

        public Criteria andStucodeNotBetween(String value1, String value2) {
            addCriterion("stucode not between", value1, value2, "stucode");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(String value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(String value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(String value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(String value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(String value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(String value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLike(String value) {
            addCriterion("type like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotLike(String value) {
            addCriterion("type not like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<String> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<String> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(String value1, String value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(String value1, String value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andDescinfoIsNull() {
            addCriterion("descinfo is null");
            return (Criteria) this;
        }

        public Criteria andDescinfoIsNotNull() {
            addCriterion("descinfo is not null");
            return (Criteria) this;
        }

        public Criteria andDescinfoEqualTo(String value) {
            addCriterion("descinfo =", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoNotEqualTo(String value) {
            addCriterion("descinfo <>", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoGreaterThan(String value) {
            addCriterion("descinfo >", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoGreaterThanOrEqualTo(String value) {
            addCriterion("descinfo >=", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoLessThan(String value) {
            addCriterion("descinfo <", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoLessThanOrEqualTo(String value) {
            addCriterion("descinfo <=", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoLike(String value) {
            addCriterion("descinfo like", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoNotLike(String value) {
            addCriterion("descinfo not like", value, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoIn(List<String> values) {
            addCriterion("descinfo in", values, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoNotIn(List<String> values) {
            addCriterion("descinfo not in", values, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoBetween(String value1, String value2) {
            addCriterion("descinfo between", value1, value2, "descinfo");
            return (Criteria) this;
        }

        public Criteria andDescinfoNotBetween(String value1, String value2) {
            addCriterion("descinfo not between", value1, value2, "descinfo");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andXianIsNull() {
            addCriterion("xian is null");
            return (Criteria) this;
        }

        public Criteria andXianIsNotNull() {
            addCriterion("xian is not null");
            return (Criteria) this;
        }

        public Criteria andXianEqualTo(String value) {
            addCriterion("xian =", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianNotEqualTo(String value) {
            addCriterion("xian <>", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianGreaterThan(String value) {
            addCriterion("xian >", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianGreaterThanOrEqualTo(String value) {
            addCriterion("xian >=", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianLessThan(String value) {
            addCriterion("xian <", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianLessThanOrEqualTo(String value) {
            addCriterion("xian <=", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianLike(String value) {
            addCriterion("xian like", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianNotLike(String value) {
            addCriterion("xian not like", value, "xian");
            return (Criteria) this;
        }

        public Criteria andXianIn(List<String> values) {
            addCriterion("xian in", values, "xian");
            return (Criteria) this;
        }

        public Criteria andXianNotIn(List<String> values) {
            addCriterion("xian not in", values, "xian");
            return (Criteria) this;
        }

        public Criteria andXianBetween(String value1, String value2) {
            addCriterion("xian between", value1, value2, "xian");
            return (Criteria) this;
        }

        public Criteria andXianNotBetween(String value1, String value2) {
            addCriterion("xian not between", value1, value2, "xian");
            return (Criteria) this;
        }

        public Criteria andTownIsNull() {
            addCriterion("town is null");
            return (Criteria) this;
        }

        public Criteria andTownIsNotNull() {
            addCriterion("town is not null");
            return (Criteria) this;
        }

        public Criteria andTownEqualTo(String value) {
            addCriterion("town =", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownNotEqualTo(String value) {
            addCriterion("town <>", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownGreaterThan(String value) {
            addCriterion("town >", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownGreaterThanOrEqualTo(String value) {
            addCriterion("town >=", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownLessThan(String value) {
            addCriterion("town <", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownLessThanOrEqualTo(String value) {
            addCriterion("town <=", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownLike(String value) {
            addCriterion("town like", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownNotLike(String value) {
            addCriterion("town not like", value, "town");
            return (Criteria) this;
        }

        public Criteria andTownIn(List<String> values) {
            addCriterion("town in", values, "town");
            return (Criteria) this;
        }

        public Criteria andTownNotIn(List<String> values) {
            addCriterion("town not in", values, "town");
            return (Criteria) this;
        }

        public Criteria andTownBetween(String value1, String value2) {
            addCriterion("town between", value1, value2, "town");
            return (Criteria) this;
        }

        public Criteria andTownNotBetween(String value1, String value2) {
            addCriterion("town not between", value1, value2, "town");
            return (Criteria) this;
        }

        public Criteria andCountryIsNull() {
            addCriterion("country is null");
            return (Criteria) this;
        }

        public Criteria andCountryIsNotNull() {
            addCriterion("country is not null");
            return (Criteria) this;
        }

        public Criteria andCountryEqualTo(String value) {
            addCriterion("country =", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotEqualTo(String value) {
            addCriterion("country <>", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThan(String value) {
            addCriterion("country >", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThanOrEqualTo(String value) {
            addCriterion("country >=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThan(String value) {
            addCriterion("country <", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThanOrEqualTo(String value) {
            addCriterion("country <=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLike(String value) {
            addCriterion("country like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotLike(String value) {
            addCriterion("country not like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryIn(List<String> values) {
            addCriterion("country in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotIn(List<String> values) {
            addCriterion("country not in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryBetween(String value1, String value2) {
            addCriterion("country between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotBetween(String value1, String value2) {
            addCriterion("country not between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountrygroupIsNull() {
            addCriterion("countrygroup is null");
            return (Criteria) this;
        }

        public Criteria andCountrygroupIsNotNull() {
            addCriterion("countrygroup is not null");
            return (Criteria) this;
        }

        public Criteria andCountrygroupEqualTo(String value) {
            addCriterion("countrygroup =", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupNotEqualTo(String value) {
            addCriterion("countrygroup <>", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupGreaterThan(String value) {
            addCriterion("countrygroup >", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupGreaterThanOrEqualTo(String value) {
            addCriterion("countrygroup >=", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupLessThan(String value) {
            addCriterion("countrygroup <", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupLessThanOrEqualTo(String value) {
            addCriterion("countrygroup <=", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupLike(String value) {
            addCriterion("countrygroup like", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupNotLike(String value) {
            addCriterion("countrygroup not like", value, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupIn(List<String> values) {
            addCriterion("countrygroup in", values, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupNotIn(List<String> values) {
            addCriterion("countrygroup not in", values, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupBetween(String value1, String value2) {
            addCriterion("countrygroup between", value1, value2, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andCountrygroupNotBetween(String value1, String value2) {
            addCriterion("countrygroup not between", value1, value2, "countrygroup");
            return (Criteria) this;
        }

        public Criteria andParentnameIsNull() {
            addCriterion("parentname is null");
            return (Criteria) this;
        }

        public Criteria andParentnameIsNotNull() {
            addCriterion("parentname is not null");
            return (Criteria) this;
        }

        public Criteria andParentnameEqualTo(String value) {
            addCriterion("parentname =", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameNotEqualTo(String value) {
            addCriterion("parentname <>", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameGreaterThan(String value) {
            addCriterion("parentname >", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameGreaterThanOrEqualTo(String value) {
            addCriterion("parentname >=", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameLessThan(String value) {
            addCriterion("parentname <", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameLessThanOrEqualTo(String value) {
            addCriterion("parentname <=", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameLike(String value) {
            addCriterion("parentname like", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameNotLike(String value) {
            addCriterion("parentname not like", value, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameIn(List<String> values) {
            addCriterion("parentname in", values, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameNotIn(List<String> values) {
            addCriterion("parentname not in", values, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameBetween(String value1, String value2) {
            addCriterion("parentname between", value1, value2, "parentname");
            return (Criteria) this;
        }

        public Criteria andParentnameNotBetween(String value1, String value2) {
            addCriterion("parentname not between", value1, value2, "parentname");
            return (Criteria) this;
        }

        public Criteria andRelationIsNull() {
            addCriterion("relation is null");
            return (Criteria) this;
        }

        public Criteria andRelationIsNotNull() {
            addCriterion("relation is not null");
            return (Criteria) this;
        }

        public Criteria andRelationEqualTo(String value) {
            addCriterion("relation =", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotEqualTo(String value) {
            addCriterion("relation <>", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationGreaterThan(String value) {
            addCriterion("relation >", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationGreaterThanOrEqualTo(String value) {
            addCriterion("relation >=", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationLessThan(String value) {
            addCriterion("relation <", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationLessThanOrEqualTo(String value) {
            addCriterion("relation <=", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationLike(String value) {
            addCriterion("relation like", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotLike(String value) {
            addCriterion("relation not like", value, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationIn(List<String> values) {
            addCriterion("relation in", values, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotIn(List<String> values) {
            addCriterion("relation not in", values, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationBetween(String value1, String value2) {
            addCriterion("relation between", value1, value2, "relation");
            return (Criteria) this;
        }

        public Criteria andRelationNotBetween(String value1, String value2) {
            addCriterion("relation not between", value1, value2, "relation");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andBanknoIsNull() {
            addCriterion("bankno is null");
            return (Criteria) this;
        }

        public Criteria andBanknoIsNotNull() {
            addCriterion("bankno is not null");
            return (Criteria) this;
        }

        public Criteria andBanknoEqualTo(String value) {
            addCriterion("bankno =", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoNotEqualTo(String value) {
            addCriterion("bankno <>", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoGreaterThan(String value) {
            addCriterion("bankno >", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoGreaterThanOrEqualTo(String value) {
            addCriterion("bankno >=", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoLessThan(String value) {
            addCriterion("bankno <", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoLessThanOrEqualTo(String value) {
            addCriterion("bankno <=", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoLike(String value) {
            addCriterion("bankno like", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoNotLike(String value) {
            addCriterion("bankno not like", value, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoIn(List<String> values) {
            addCriterion("bankno in", values, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoNotIn(List<String> values) {
            addCriterion("bankno not in", values, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoBetween(String value1, String value2) {
            addCriterion("bankno between", value1, value2, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknoNotBetween(String value1, String value2) {
            addCriterion("bankno not between", value1, value2, "bankno");
            return (Criteria) this;
        }

        public Criteria andBanknameIsNull() {
            addCriterion("bankname is null");
            return (Criteria) this;
        }

        public Criteria andBanknameIsNotNull() {
            addCriterion("bankname is not null");
            return (Criteria) this;
        }

        public Criteria andBanknameEqualTo(String value) {
            addCriterion("bankname =", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotEqualTo(String value) {
            addCriterion("bankname <>", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameGreaterThan(String value) {
            addCriterion("bankname >", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameGreaterThanOrEqualTo(String value) {
            addCriterion("bankname >=", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLessThan(String value) {
            addCriterion("bankname <", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLessThanOrEqualTo(String value) {
            addCriterion("bankname <=", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLike(String value) {
            addCriterion("bankname like", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotLike(String value) {
            addCriterion("bankname not like", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameIn(List<String> values) {
            addCriterion("bankname in", values, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotIn(List<String> values) {
            addCriterion("bankname not in", values, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameBetween(String value1, String value2) {
            addCriterion("bankname between", value1, value2, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotBetween(String value1, String value2) {
            addCriterion("bankname not between", value1, value2, "bankname");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(BigDecimal value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(BigDecimal value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(BigDecimal value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(BigDecimal value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<BigDecimal> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<BigDecimal> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andApplyfileIsNull() {
            addCriterion("applyfile is null");
            return (Criteria) this;
        }

        public Criteria andApplyfileIsNotNull() {
            addCriterion("applyfile is not null");
            return (Criteria) this;
        }

        public Criteria andApplyfileEqualTo(String value) {
            addCriterion("applyfile =", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileNotEqualTo(String value) {
            addCriterion("applyfile <>", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileGreaterThan(String value) {
            addCriterion("applyfile >", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileGreaterThanOrEqualTo(String value) {
            addCriterion("applyfile >=", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileLessThan(String value) {
            addCriterion("applyfile <", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileLessThanOrEqualTo(String value) {
            addCriterion("applyfile <=", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileLike(String value) {
            addCriterion("applyfile like", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileNotLike(String value) {
            addCriterion("applyfile not like", value, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileIn(List<String> values) {
            addCriterion("applyfile in", values, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileNotIn(List<String> values) {
            addCriterion("applyfile not in", values, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileBetween(String value1, String value2) {
            addCriterion("applyfile between", value1, value2, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApplyfileNotBetween(String value1, String value2) {
            addCriterion("applyfile not between", value1, value2, "applyfile");
            return (Criteria) this;
        }

        public Criteria andApply2fileIsNull() {
            addCriterion("apply2file is null");
            return (Criteria) this;
        }

        public Criteria andApply2fileIsNotNull() {
            addCriterion("apply2file is not null");
            return (Criteria) this;
        }

        public Criteria andApply2fileEqualTo(String value) {
            addCriterion("apply2file =", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileNotEqualTo(String value) {
            addCriterion("apply2file <>", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileGreaterThan(String value) {
            addCriterion("apply2file >", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileGreaterThanOrEqualTo(String value) {
            addCriterion("apply2file >=", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileLessThan(String value) {
            addCriterion("apply2file <", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileLessThanOrEqualTo(String value) {
            addCriterion("apply2file <=", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileLike(String value) {
            addCriterion("apply2file like", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileNotLike(String value) {
            addCriterion("apply2file not like", value, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileIn(List<String> values) {
            addCriterion("apply2file in", values, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileNotIn(List<String> values) {
            addCriterion("apply2file not in", values, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileBetween(String value1, String value2) {
            addCriterion("apply2file between", value1, value2, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply2fileNotBetween(String value1, String value2) {
            addCriterion("apply2file not between", value1, value2, "apply2file");
            return (Criteria) this;
        }

        public Criteria andApply3fileIsNull() {
            addCriterion("apply3file is null");
            return (Criteria) this;
        }

        public Criteria andApply3fileIsNotNull() {
            addCriterion("apply3file is not null");
            return (Criteria) this;
        }

        public Criteria andApply3fileEqualTo(String value) {
            addCriterion("apply3file =", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileNotEqualTo(String value) {
            addCriterion("apply3file <>", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileGreaterThan(String value) {
            addCriterion("apply3file >", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileGreaterThanOrEqualTo(String value) {
            addCriterion("apply3file >=", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileLessThan(String value) {
            addCriterion("apply3file <", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileLessThanOrEqualTo(String value) {
            addCriterion("apply3file <=", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileLike(String value) {
            addCriterion("apply3file like", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileNotLike(String value) {
            addCriterion("apply3file not like", value, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileIn(List<String> values) {
            addCriterion("apply3file in", values, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileNotIn(List<String> values) {
            addCriterion("apply3file not in", values, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileBetween(String value1, String value2) {
            addCriterion("apply3file between", value1, value2, "apply3file");
            return (Criteria) this;
        }

        public Criteria andApply3fileNotBetween(String value1, String value2) {
            addCriterion("apply3file not between", value1, value2, "apply3file");
            return (Criteria) this;
        }

        public Criteria andIdcardfileIsNull() {
            addCriterion("idcardfile is null");
            return (Criteria) this;
        }

        public Criteria andIdcardfileIsNotNull() {
            addCriterion("idcardfile is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardfileEqualTo(String value) {
            addCriterion("idcardfile =", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileNotEqualTo(String value) {
            addCriterion("idcardfile <>", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileGreaterThan(String value) {
            addCriterion("idcardfile >", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileGreaterThanOrEqualTo(String value) {
            addCriterion("idcardfile >=", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileLessThan(String value) {
            addCriterion("idcardfile <", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileLessThanOrEqualTo(String value) {
            addCriterion("idcardfile <=", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileLike(String value) {
            addCriterion("idcardfile like", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileNotLike(String value) {
            addCriterion("idcardfile not like", value, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileIn(List<String> values) {
            addCriterion("idcardfile in", values, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileNotIn(List<String> values) {
            addCriterion("idcardfile not in", values, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileBetween(String value1, String value2) {
            addCriterion("idcardfile between", value1, value2, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcardfileNotBetween(String value1, String value2) {
            addCriterion("idcardfile not between", value1, value2, "idcardfile");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileIsNull() {
            addCriterion("idcard2file is null");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileIsNotNull() {
            addCriterion("idcard2file is not null");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileEqualTo(String value) {
            addCriterion("idcard2file =", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileNotEqualTo(String value) {
            addCriterion("idcard2file <>", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileGreaterThan(String value) {
            addCriterion("idcard2file >", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileGreaterThanOrEqualTo(String value) {
            addCriterion("idcard2file >=", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileLessThan(String value) {
            addCriterion("idcard2file <", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileLessThanOrEqualTo(String value) {
            addCriterion("idcard2file <=", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileLike(String value) {
            addCriterion("idcard2file like", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileNotLike(String value) {
            addCriterion("idcard2file not like", value, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileIn(List<String> values) {
            addCriterion("idcard2file in", values, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileNotIn(List<String> values) {
            addCriterion("idcard2file not in", values, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileBetween(String value1, String value2) {
            addCriterion("idcard2file between", value1, value2, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andIdcard2fileNotBetween(String value1, String value2) {
            addCriterion("idcard2file not between", value1, value2, "idcard2file");
            return (Criteria) this;
        }

        public Criteria andStufileIsNull() {
            addCriterion("stufile is null");
            return (Criteria) this;
        }

        public Criteria andStufileIsNotNull() {
            addCriterion("stufile is not null");
            return (Criteria) this;
        }

        public Criteria andStufileEqualTo(String value) {
            addCriterion("stufile =", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileNotEqualTo(String value) {
            addCriterion("stufile <>", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileGreaterThan(String value) {
            addCriterion("stufile >", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileGreaterThanOrEqualTo(String value) {
            addCriterion("stufile >=", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileLessThan(String value) {
            addCriterion("stufile <", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileLessThanOrEqualTo(String value) {
            addCriterion("stufile <=", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileLike(String value) {
            addCriterion("stufile like", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileNotLike(String value) {
            addCriterion("stufile not like", value, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileIn(List<String> values) {
            addCriterion("stufile in", values, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileNotIn(List<String> values) {
            addCriterion("stufile not in", values, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileBetween(String value1, String value2) {
            addCriterion("stufile between", value1, value2, "stufile");
            return (Criteria) this;
        }

        public Criteria andStufileNotBetween(String value1, String value2) {
            addCriterion("stufile not between", value1, value2, "stufile");
            return (Criteria) this;
        }

        public Criteria andAddressfileIsNull() {
            addCriterion("addressfile is null");
            return (Criteria) this;
        }

        public Criteria andAddressfileIsNotNull() {
            addCriterion("addressfile is not null");
            return (Criteria) this;
        }

        public Criteria andAddressfileEqualTo(String value) {
            addCriterion("addressfile =", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileNotEqualTo(String value) {
            addCriterion("addressfile <>", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileGreaterThan(String value) {
            addCriterion("addressfile >", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileGreaterThanOrEqualTo(String value) {
            addCriterion("addressfile >=", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileLessThan(String value) {
            addCriterion("addressfile <", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileLessThanOrEqualTo(String value) {
            addCriterion("addressfile <=", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileLike(String value) {
            addCriterion("addressfile like", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileNotLike(String value) {
            addCriterion("addressfile not like", value, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileIn(List<String> values) {
            addCriterion("addressfile in", values, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileNotIn(List<String> values) {
            addCriterion("addressfile not in", values, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileBetween(String value1, String value2) {
            addCriterion("addressfile between", value1, value2, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddressfileNotBetween(String value1, String value2) {
            addCriterion("addressfile not between", value1, value2, "addressfile");
            return (Criteria) this;
        }

        public Criteria andAddress2fileIsNull() {
            addCriterion("address2file is null");
            return (Criteria) this;
        }

        public Criteria andAddress2fileIsNotNull() {
            addCriterion("address2file is not null");
            return (Criteria) this;
        }

        public Criteria andAddress2fileEqualTo(String value) {
            addCriterion("address2file =", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileNotEqualTo(String value) {
            addCriterion("address2file <>", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileGreaterThan(String value) {
            addCriterion("address2file >", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileGreaterThanOrEqualTo(String value) {
            addCriterion("address2file >=", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileLessThan(String value) {
            addCriterion("address2file <", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileLessThanOrEqualTo(String value) {
            addCriterion("address2file <=", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileLike(String value) {
            addCriterion("address2file like", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileNotLike(String value) {
            addCriterion("address2file not like", value, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileIn(List<String> values) {
            addCriterion("address2file in", values, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileNotIn(List<String> values) {
            addCriterion("address2file not in", values, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileBetween(String value1, String value2) {
            addCriterion("address2file between", value1, value2, "address2file");
            return (Criteria) this;
        }

        public Criteria andAddress2fileNotBetween(String value1, String value2) {
            addCriterion("address2file not between", value1, value2, "address2file");
            return (Criteria) this;
        }

        public Criteria andBankfileIsNull() {
            addCriterion("bankfile is null");
            return (Criteria) this;
        }

        public Criteria andBankfileIsNotNull() {
            addCriterion("bankfile is not null");
            return (Criteria) this;
        }

        public Criteria andBankfileEqualTo(String value) {
            addCriterion("bankfile =", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileNotEqualTo(String value) {
            addCriterion("bankfile <>", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileGreaterThan(String value) {
            addCriterion("bankfile >", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileGreaterThanOrEqualTo(String value) {
            addCriterion("bankfile >=", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileLessThan(String value) {
            addCriterion("bankfile <", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileLessThanOrEqualTo(String value) {
            addCriterion("bankfile <=", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileLike(String value) {
            addCriterion("bankfile like", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileNotLike(String value) {
            addCriterion("bankfile not like", value, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileIn(List<String> values) {
            addCriterion("bankfile in", values, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileNotIn(List<String> values) {
            addCriterion("bankfile not in", values, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileBetween(String value1, String value2) {
            addCriterion("bankfile between", value1, value2, "bankfile");
            return (Criteria) this;
        }

        public Criteria andBankfileNotBetween(String value1, String value2) {
            addCriterion("bankfile not between", value1, value2, "bankfile");
            return (Criteria) this;
        }

        public Criteria andUidIsNull() {
            addCriterion("uid is null");
            return (Criteria) this;
        }

        public Criteria andUidIsNotNull() {
            addCriterion("uid is not null");
            return (Criteria) this;
        }

        public Criteria andUidEqualTo(Integer value) {
            addCriterion("uid =", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotEqualTo(Integer value) {
            addCriterion("uid <>", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThan(Integer value) {
            addCriterion("uid >", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThanOrEqualTo(Integer value) {
            addCriterion("uid >=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThan(Integer value) {
            addCriterion("uid <", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThanOrEqualTo(Integer value) {
            addCriterion("uid <=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidIn(List<Integer> values) {
            addCriterion("uid in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotIn(List<Integer> values) {
            addCriterion("uid not in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidBetween(Integer value1, Integer value2) {
            addCriterion("uid between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotBetween(Integer value1, Integer value2) {
            addCriterion("uid not between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andFinishdateIsNull() {
            addCriterion("finishdate is null");
            return (Criteria) this;
        }

        public Criteria andFinishdateIsNotNull() {
            addCriterion("finishdate is not null");
            return (Criteria) this;
        }

        public Criteria andFinishdateEqualTo(Date value) {
            addCriterion("finishdate =", value, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateNotEqualTo(Date value) {
            addCriterion("finishdate <>", value, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateGreaterThan(Date value) {
            addCriterion("finishdate >", value, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateGreaterThanOrEqualTo(Date value) {
            addCriterion("finishdate >=", value, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateLessThan(Date value) {
            addCriterion("finishdate <", value, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateLessThanOrEqualTo(Date value) {
            addCriterion("finishdate <=", value, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateIn(List<Date> values) {
            addCriterion("finishdate in", values, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateNotIn(List<Date> values) {
            addCriterion("finishdate not in", values, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateBetween(Date value1, Date value2) {
            addCriterion("finishdate between", value1, value2, "finishdate");
            return (Criteria) this;
        }

        public Criteria andFinishdateNotBetween(Date value1, Date value2) {
            addCriterion("finishdate not between", value1, value2, "finishdate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}